package com.rf.richfitwheel.admin.basedata.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BasicDataOrgTreeExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BasicDataOrgTreeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andMyIdIsNull() {
            addCriterion("my_id is null");
            return (Criteria) this;
        }

        public Criteria andMyIdIsNotNull() {
            addCriterion("my_id is not null");
            return (Criteria) this;
        }

        public Criteria andMyIdEqualTo(String value) {
            addCriterion("my_id =", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdNotEqualTo(String value) {
            addCriterion("my_id <>", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdGreaterThan(String value) {
            addCriterion("my_id >", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdGreaterThanOrEqualTo(String value) {
            addCriterion("my_id >=", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdLessThan(String value) {
            addCriterion("my_id <", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdLessThanOrEqualTo(String value) {
            addCriterion("my_id <=", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdLike(String value) {
            addCriterion("my_id like", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdNotLike(String value) {
            addCriterion("my_id not like", value, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdIn(List<String> values) {
            addCriterion("my_id in", values, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdNotIn(List<String> values) {
            addCriterion("my_id not in", values, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdBetween(String value1, String value2) {
            addCriterion("my_id between", value1, value2, "myId");
            return (Criteria) this;
        }

        public Criteria andMyIdNotBetween(String value1, String value2) {
            addCriterion("my_id not between", value1, value2, "myId");
            return (Criteria) this;
        }

        public Criteria andObjectIdIsNull() {
            addCriterion("OBJECT_ID is null");
            return (Criteria) this;
        }

        public Criteria andObjectIdIsNotNull() {
            addCriterion("OBJECT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andObjectIdEqualTo(String value) {
            addCriterion("OBJECT_ID =", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdNotEqualTo(String value) {
            addCriterion("OBJECT_ID <>", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdGreaterThan(String value) {
            addCriterion("OBJECT_ID >", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdGreaterThanOrEqualTo(String value) {
            addCriterion("OBJECT_ID >=", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdLessThan(String value) {
            addCriterion("OBJECT_ID <", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdLessThanOrEqualTo(String value) {
            addCriterion("OBJECT_ID <=", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdLike(String value) {
            addCriterion("OBJECT_ID like", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdNotLike(String value) {
            addCriterion("OBJECT_ID not like", value, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdIn(List<String> values) {
            addCriterion("OBJECT_ID in", values, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdNotIn(List<String> values) {
            addCriterion("OBJECT_ID not in", values, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdBetween(String value1, String value2) {
            addCriterion("OBJECT_ID between", value1, value2, "objectId");
            return (Criteria) this;
        }

        public Criteria andObjectIdNotBetween(String value1, String value2) {
            addCriterion("OBJECT_ID not between", value1, value2, "objectId");
            return (Criteria) this;
        }

        public Criteria andVersionNumberIsNull() {
            addCriterion("VERSION_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andVersionNumberIsNotNull() {
            addCriterion("VERSION_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andVersionNumberEqualTo(Integer value) {
            addCriterion("VERSION_NUMBER =", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberNotEqualTo(Integer value) {
            addCriterion("VERSION_NUMBER <>", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberGreaterThan(Integer value) {
            addCriterion("VERSION_NUMBER >", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("VERSION_NUMBER >=", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberLessThan(Integer value) {
            addCriterion("VERSION_NUMBER <", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberLessThanOrEqualTo(Integer value) {
            addCriterion("VERSION_NUMBER <=", value, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberIn(List<Integer> values) {
            addCriterion("VERSION_NUMBER in", values, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberNotIn(List<Integer> values) {
            addCriterion("VERSION_NUMBER not in", values, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberBetween(Integer value1, Integer value2) {
            addCriterion("VERSION_NUMBER between", value1, value2, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andVersionNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("VERSION_NUMBER not between", value1, value2, "versionNumber");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNull() {
            addCriterion("TENANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNotNull() {
            addCriterion("TENANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTenantIdEqualTo(String value) {
            addCriterion("TENANT_ID =", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(String value) {
            addCriterion("TENANT_ID <>", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThan(String value) {
            addCriterion("TENANT_ID >", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThanOrEqualTo(String value) {
            addCriterion("TENANT_ID >=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThan(String value) {
            addCriterion("TENANT_ID <", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThanOrEqualTo(String value) {
            addCriterion("TENANT_ID <=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLike(String value) {
            addCriterion("TENANT_ID like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotLike(String value) {
            addCriterion("TENANT_ID not like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdIn(List<String> values) {
            addCriterion("TENANT_ID in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotIn(List<String> values) {
            addCriterion("TENANT_ID not in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdBetween(String value1, String value2) {
            addCriterion("TENANT_ID between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotBetween(String value1, String value2) {
            addCriterion("TENANT_ID not between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("CREATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("CREATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("CREATE_BY =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("CREATE_BY <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("CREATE_BY >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("CREATE_BY <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("CREATE_BY like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("CREATE_BY not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("CREATE_BY in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("CREATE_BY not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("CREATE_BY between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("UPDATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("UPDATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("UPDATE_BY =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("UPDATE_BY <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("UPDATE_BY >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("UPDATE_BY <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("UPDATE_BY like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("UPDATE_BY not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("UPDATE_BY in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("UPDATE_BY not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("UPDATE_BY between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginIsNull() {
            addCriterion("UPDATE_LOGIN is null");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginIsNotNull() {
            addCriterion("UPDATE_LOGIN is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginEqualTo(String value) {
            addCriterion("UPDATE_LOGIN =", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginNotEqualTo(String value) {
            addCriterion("UPDATE_LOGIN <>", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginGreaterThan(String value) {
            addCriterion("UPDATE_LOGIN >", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_LOGIN >=", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginLessThan(String value) {
            addCriterion("UPDATE_LOGIN <", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_LOGIN <=", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginLike(String value) {
            addCriterion("UPDATE_LOGIN like", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginNotLike(String value) {
            addCriterion("UPDATE_LOGIN not like", value, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginIn(List<String> values) {
            addCriterion("UPDATE_LOGIN in", values, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginNotIn(List<String> values) {
            addCriterion("UPDATE_LOGIN not in", values, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginBetween(String value1, String value2) {
            addCriterion("UPDATE_LOGIN between", value1, value2, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andUpdateLoginNotBetween(String value1, String value2) {
            addCriterion("UPDATE_LOGIN not between", value1, value2, "updateLogin");
            return (Criteria) this;
        }

        public Criteria andPDeletedIsNull() {
            addCriterion("P_DELETED is null");
            return (Criteria) this;
        }

        public Criteria andPDeletedIsNotNull() {
            addCriterion("P_DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andPDeletedEqualTo(String value) {
            addCriterion("P_DELETED =", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedNotEqualTo(String value) {
            addCriterion("P_DELETED <>", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedGreaterThan(String value) {
            addCriterion("P_DELETED >", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedGreaterThanOrEqualTo(String value) {
            addCriterion("P_DELETED >=", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedLessThan(String value) {
            addCriterion("P_DELETED <", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedLessThanOrEqualTo(String value) {
            addCriterion("P_DELETED <=", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedLike(String value) {
            addCriterion("P_DELETED like", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedNotLike(String value) {
            addCriterion("P_DELETED not like", value, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedIn(List<String> values) {
            addCriterion("P_DELETED in", values, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedNotIn(List<String> values) {
            addCriterion("P_DELETED not in", values, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedBetween(String value1, String value2) {
            addCriterion("P_DELETED between", value1, value2, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andPDeletedNotBetween(String value1, String value2) {
            addCriterion("P_DELETED not between", value1, value2, "pDeleted");
            return (Criteria) this;
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIsNull() {
            addCriterion("org_type is null");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIsNotNull() {
            addCriterion("org_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrgTypeEqualTo(String value) {
            addCriterion("org_type =", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotEqualTo(String value) {
            addCriterion("org_type <>", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeGreaterThan(String value) {
            addCriterion("org_type >", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeGreaterThanOrEqualTo(String value) {
            addCriterion("org_type >=", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLessThan(String value) {
            addCriterion("org_type <", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLessThanOrEqualTo(String value) {
            addCriterion("org_type <=", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeLike(String value) {
            addCriterion("org_type like", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotLike(String value) {
            addCriterion("org_type not like", value, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeIn(List<String> values) {
            addCriterion("org_type in", values, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotIn(List<String> values) {
            addCriterion("org_type not in", values, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeBetween(String value1, String value2) {
            addCriterion("org_type between", value1, value2, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgTypeNotBetween(String value1, String value2) {
            addCriterion("org_type not between", value1, value2, "orgType");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNull() {
            addCriterion("ORG_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNotNull() {
            addCriterion("ORG_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrgNameEqualTo(String value) {
            addCriterion("ORG_NAME =", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotEqualTo(String value) {
            addCriterion("ORG_NAME <>", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThan(String value) {
            addCriterion("ORG_NAME >", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_NAME >=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThan(String value) {
            addCriterion("ORG_NAME <", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThanOrEqualTo(String value) {
            addCriterion("ORG_NAME <=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLike(String value) {
            addCriterion("ORG_NAME like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotLike(String value) {
            addCriterion("ORG_NAME not like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameIn(List<String> values) {
            addCriterion("ORG_NAME in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotIn(List<String> values) {
            addCriterion("ORG_NAME not in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameBetween(String value1, String value2) {
            addCriterion("ORG_NAME between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotBetween(String value1, String value2) {
            addCriterion("ORG_NAME not between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNull() {
            addCriterion("parent_id is null");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNotNull() {
            addCriterion("parent_id is not null");
            return (Criteria) this;
        }

        public Criteria andParentIdEqualTo(String value) {
            addCriterion("parent_id =", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotEqualTo(String value) {
            addCriterion("parent_id <>", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThan(String value) {
            addCriterion("parent_id >", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThanOrEqualTo(String value) {
            addCriterion("parent_id >=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThan(String value) {
            addCriterion("parent_id <", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThanOrEqualTo(String value) {
            addCriterion("parent_id <=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLike(String value) {
            addCriterion("parent_id like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotLike(String value) {
            addCriterion("parent_id not like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdIn(List<String> values) {
            addCriterion("parent_id in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotIn(List<String> values) {
            addCriterion("parent_id not in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdBetween(String value1, String value2) {
            addCriterion("parent_id between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotBetween(String value1, String value2) {
            addCriterion("parent_id not between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNull() {
            addCriterion("short_name is null");
            return (Criteria) this;
        }

        public Criteria andShortNameIsNotNull() {
            addCriterion("short_name is not null");
            return (Criteria) this;
        }

        public Criteria andShortNameEqualTo(String value) {
            addCriterion("short_name =", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotEqualTo(String value) {
            addCriterion("short_name <>", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThan(String value) {
            addCriterion("short_name >", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameGreaterThanOrEqualTo(String value) {
            addCriterion("short_name >=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThan(String value) {
            addCriterion("short_name <", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLessThanOrEqualTo(String value) {
            addCriterion("short_name <=", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameLike(String value) {
            addCriterion("short_name like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotLike(String value) {
            addCriterion("short_name not like", value, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameIn(List<String> values) {
            addCriterion("short_name in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotIn(List<String> values) {
            addCriterion("short_name not in", values, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameBetween(String value1, String value2) {
            addCriterion("short_name between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andShortNameNotBetween(String value1, String value2) {
            addCriterion("short_name not between", value1, value2, "shortName");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIsNull() {
            addCriterion("social_credit_code is null");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIsNotNull() {
            addCriterion("social_credit_code is not null");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeEqualTo(String value) {
            addCriterion("social_credit_code =", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotEqualTo(String value) {
            addCriterion("social_credit_code <>", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeGreaterThan(String value) {
            addCriterion("social_credit_code >", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("social_credit_code >=", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLessThan(String value) {
            addCriterion("social_credit_code <", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("social_credit_code <=", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeLike(String value) {
            addCriterion("social_credit_code like", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotLike(String value) {
            addCriterion("social_credit_code not like", value, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeIn(List<String> values) {
            addCriterion("social_credit_code in", values, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotIn(List<String> values) {
            addCriterion("social_credit_code not in", values, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeBetween(String value1, String value2) {
            addCriterion("social_credit_code between", value1, value2, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andSocialCreditCodeNotBetween(String value1, String value2) {
            addCriterion("social_credit_code not between", value1, value2, "socialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeIsNull() {
            addCriterion("parent_social_credit_code is null");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeIsNotNull() {
            addCriterion("parent_social_credit_code is not null");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeEqualTo(String value) {
            addCriterion("parent_social_credit_code =", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeNotEqualTo(String value) {
            addCriterion("parent_social_credit_code <>", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeGreaterThan(String value) {
            addCriterion("parent_social_credit_code >", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeGreaterThanOrEqualTo(String value) {
            addCriterion("parent_social_credit_code >=", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeLessThan(String value) {
            addCriterion("parent_social_credit_code <", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeLessThanOrEqualTo(String value) {
            addCriterion("parent_social_credit_code <=", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeLike(String value) {
            addCriterion("parent_social_credit_code like", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeNotLike(String value) {
            addCriterion("parent_social_credit_code not like", value, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeIn(List<String> values) {
            addCriterion("parent_social_credit_code in", values, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeNotIn(List<String> values) {
            addCriterion("parent_social_credit_code not in", values, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeBetween(String value1, String value2) {
            addCriterion("parent_social_credit_code between", value1, value2, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andParentSocialCreditCodeNotBetween(String value1, String value2) {
            addCriterion("parent_social_credit_code not between", value1, value2, "parentSocialCreditCode");
            return (Criteria) this;
        }

        public Criteria andOrgLevelIsNull() {
            addCriterion("org_level is null");
            return (Criteria) this;
        }

        public Criteria andOrgLevelIsNotNull() {
            addCriterion("org_level is not null");
            return (Criteria) this;
        }

        public Criteria andOrgLevelEqualTo(String value) {
            addCriterion("org_level =", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelNotEqualTo(String value) {
            addCriterion("org_level <>", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelGreaterThan(String value) {
            addCriterion("org_level >", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelGreaterThanOrEqualTo(String value) {
            addCriterion("org_level >=", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelLessThan(String value) {
            addCriterion("org_level <", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelLessThanOrEqualTo(String value) {
            addCriterion("org_level <=", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelLike(String value) {
            addCriterion("org_level like", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelNotLike(String value) {
            addCriterion("org_level not like", value, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelIn(List<String> values) {
            addCriterion("org_level in", values, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelNotIn(List<String> values) {
            addCriterion("org_level not in", values, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelBetween(String value1, String value2) {
            addCriterion("org_level between", value1, value2, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andOrgLevelNotBetween(String value1, String value2) {
            addCriterion("org_level not between", value1, value2, "orgLevel");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticIsNull() {
            addCriterion("abroad_domestic is null");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticIsNotNull() {
            addCriterion("abroad_domestic is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticEqualTo(String value) {
            addCriterion("abroad_domestic =", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticNotEqualTo(String value) {
            addCriterion("abroad_domestic <>", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticGreaterThan(String value) {
            addCriterion("abroad_domestic >", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticGreaterThanOrEqualTo(String value) {
            addCriterion("abroad_domestic >=", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticLessThan(String value) {
            addCriterion("abroad_domestic <", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticLessThanOrEqualTo(String value) {
            addCriterion("abroad_domestic <=", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticLike(String value) {
            addCriterion("abroad_domestic like", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticNotLike(String value) {
            addCriterion("abroad_domestic not like", value, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticIn(List<String> values) {
            addCriterion("abroad_domestic in", values, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticNotIn(List<String> values) {
            addCriterion("abroad_domestic not in", values, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticBetween(String value1, String value2) {
            addCriterion("abroad_domestic between", value1, value2, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andAbroadDomesticNotBetween(String value1, String value2) {
            addCriterion("abroad_domestic not between", value1, value2, "abroadDomestic");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIsNull() {
            addCriterion("customer_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIsNotNull() {
            addCriterion("customer_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeEqualTo(String value) {
            addCriterion("customer_code =", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotEqualTo(String value) {
            addCriterion("customer_code <>", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThan(String value) {
            addCriterion("customer_code >", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_code >=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThan(String value) {
            addCriterion("customer_code <", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_code <=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLike(String value) {
            addCriterion("customer_code like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotLike(String value) {
            addCriterion("customer_code not like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIn(List<String> values) {
            addCriterion("customer_code in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotIn(List<String> values) {
            addCriterion("customer_code not in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeBetween(String value1, String value2) {
            addCriterion("customer_code between", value1, value2, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotBetween(String value1, String value2) {
            addCriterion("customer_code not between", value1, value2, "customerCode");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameIsNull() {
            addCriterion("directly_org_name is null");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameIsNotNull() {
            addCriterion("directly_org_name is not null");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameEqualTo(String value) {
            addCriterion("directly_org_name =", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameNotEqualTo(String value) {
            addCriterion("directly_org_name <>", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameGreaterThan(String value) {
            addCriterion("directly_org_name >", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameGreaterThanOrEqualTo(String value) {
            addCriterion("directly_org_name >=", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameLessThan(String value) {
            addCriterion("directly_org_name <", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameLessThanOrEqualTo(String value) {
            addCriterion("directly_org_name <=", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameLike(String value) {
            addCriterion("directly_org_name like", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameNotLike(String value) {
            addCriterion("directly_org_name not like", value, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameIn(List<String> values) {
            addCriterion("directly_org_name in", values, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameNotIn(List<String> values) {
            addCriterion("directly_org_name not in", values, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameBetween(String value1, String value2) {
            addCriterion("directly_org_name between", value1, value2, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andDirectlyOrgNameNotBetween(String value1, String value2) {
            addCriterion("directly_org_name not between", value1, value2, "directlyOrgName");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("country is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("country is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("country =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("country <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("country >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("country >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("country <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("country <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("country like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("country not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("country in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("country not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("country between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("country not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andMyTimeIsNull() {
            addCriterion("my_time is null");
            return (Criteria) this;
        }

        public Criteria andMyTimeIsNotNull() {
            addCriterion("my_time is not null");
            return (Criteria) this;
        }

        public Criteria andMyTimeEqualTo(Long value) {
            addCriterion("my_time =", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeNotEqualTo(Long value) {
            addCriterion("my_time <>", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeGreaterThan(Long value) {
            addCriterion("my_time >", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeGreaterThanOrEqualTo(Long value) {
            addCriterion("my_time >=", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeLessThan(Long value) {
            addCriterion("my_time <", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeLessThanOrEqualTo(Long value) {
            addCriterion("my_time <=", value, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeIn(List<Long> values) {
            addCriterion("my_time in", values, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeNotIn(List<Long> values) {
            addCriterion("my_time not in", values, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeBetween(Long value1, Long value2) {
            addCriterion("my_time between", value1, value2, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeNotBetween(Long value1, Long value2) {
            addCriterion("my_time not between", value1, value2, "myTime");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatIsNull() {
            addCriterion("my_time_mat is null");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatIsNotNull() {
            addCriterion("my_time_mat is not null");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatEqualTo(Date value) {
            addCriterion("my_time_mat =", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatNotEqualTo(Date value) {
            addCriterion("my_time_mat <>", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatGreaterThan(Date value) {
            addCriterion("my_time_mat >", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatGreaterThanOrEqualTo(Date value) {
            addCriterion("my_time_mat >=", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatLessThan(Date value) {
            addCriterion("my_time_mat <", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatLessThanOrEqualTo(Date value) {
            addCriterion("my_time_mat <=", value, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatIn(List<Date> values) {
            addCriterion("my_time_mat in", values, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatNotIn(List<Date> values) {
            addCriterion("my_time_mat not in", values, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatBetween(Date value1, Date value2) {
            addCriterion("my_time_mat between", value1, value2, "myTimeMat");
            return (Criteria) this;
        }

        public Criteria andMyTimeMatNotBetween(Date value1, Date value2) {
            addCriterion("my_time_mat not between", value1, value2, "myTimeMat");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}